Boolean Basics

Following is a guide to available logical operators that can be used to specify rules for filters and action commands.

Logical Operator	Example	Result	Additional notes
AND	@Q1=Male AND @Q2=Under 18	Males under 18
OR	@Q2=Under 18 OR @Q2=18-24	Anyone under 25
Using parentheses	@Q1=Male AND (@Q2=Under 18 OR @Q2=18-24)	Males under 25	Conditions within parentheses are processed first
LIKE	@Date LIKE '2016-03-%' OR @Date LIKE '%.03.2016'	Any date in March 2016	The % acts as a wildcard, it matches one or more characters
BETWEEN	@Q1 BETWEEN 2 AND 5	Any value between 2 and 5
IN	@StoreNum IN (123,132,176,297,804)	Any value listed within the parentheses
IS NULL	@Q1 IS NULL	No value stored for Q1 (empty data)	Questions that are skipped will have null data
IS NOT NULL	@Q1 IS NOT NULL	Any value for Q1
>	@Q1>2	Any value greater than 2
<	@Q1<5	Any value less than 5
>=	@Q1>=2	Any value greater than or equal to 2
<=	@Q1<=5	Any value less than or equal to 5